ActiveReports 9
Expressions in Reports
Show AllShow All
Hide AllHide All

You can use expressions in the control's properties to calculate values. You can also use expressions to concatenate fields, to concatenate strings with fields, to aggregate data, to set formatting based on field values, to show or hide other controls based on field values and even to display a graphical representation of the data. This walkthrough illustrates the how to use expressions to achieve different effects.

The walkthrough is split into the following activities:

Note:
  • This walkthrough uses the MovieProduct table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located in the [User Documents folder]\ComponentOne Samples\ActiveReports 9\Data folder.
  • Although this walkthrough uses Page reports, but this can be implemented using RDL reports also.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at runtime.

Design Time Layout

Runtime Layout

To add an ActiveReport to the Visual Studio project

To connect the report to a data source

To add a dataset

To create a layout for the report

To add a field expression to a text box to multiply two field values

To add an Immediate If expression to show or hide a report control

To add a Data Visualization expression to display data graphically

To view the report

See Also

Concepts

 

 


Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum